Management of hierarchical reference data

ABSTRACT

There are methods and apparatus, including computer program products, for managing hierarchical reference data. There is a Web page for access by a user, where the Web page includes (i) data representing a hierarchy and (ii) rules defining modifications that are permitted to be made to data. The user is enabled to make a real-time modification to the data based on the rules.

BACKGROUND

The present invention relates to data processing by a computing device,and more particularly to management of hierarchical reference data.

User interface programs facilitate the interaction between humans andmachines by inviting and responding to interaction from a user. Userinterfaces come in many varieties, and are designed to work in concertwith an application program. A common situation involving userinterfaces is a network connection between a server and one or moreclients. The client/server relationship is one in which a serverprovides services to other computer programs in the same or othercomputers, the client devices. Both the clients and the server typicallyhave a network interface for accessing networks such as a local areanetwork (LAN), a wide area network (WAN), or the Internet.

A common client device is a personal computer and a common userinterface application for a network environment is a Web browserapplication program. The browser allows networked communication betweenthe client device and a server using a data transfer protocol, e.g., theHypertext Transfer Protocol (HTTP), to exchange files, images, orprograms. HTTP is a request/response type protocol that specifies howthe client and the server communicate with each other. The server mayreceive a request from the browser using HTTP, respond to it, and thenclose the connection. HTTP is a stateless protocol, meaning that eachtime a client requests a Web page, the server will respond to therequest independently of any previous requests by the client, andwithout recording the request.

The contents of a file transmitted from the server and intended fordisplay in a browser on the client device may be marked up withHypertext Markup Language (HTML) code or Extensible Markup Language(XML). HTML is a language that is used to describe the structure of adocument, such as a Web page. Browsers interpret the HTML code todetermine how to display the information contained in the page. A usermay request a Web page from a server by clicking a hyperlink or enteringa Uniform Resource Locator (URL) string. A URL is the address of a filethat may be accessed on the Internet. The address identifies the Webserver it is stored on and the directory in which the file is located.When the server receiving the URL request finds the sought Web page, theserver sends the page to the browser so that the browser can process thepage, for example, generate a display based on the contents of the Webpage.

SUMMARY OF THE INVENTION

The description describes methods and apparatus, including computerprogram products, for management of hierarchical reference data. In oneaspect there is a method for managing hierarchical reference data. Themethod includes making available a Web page for access by a user, wherethe Web page includes (i) data representing a hierarchy and (ii) rulesdefining modifications that are permitted to be made to data. The methodalso includes enabling a user to make a real-time modification to thedata based on the rules.

In another aspect there is a method for managing hierarchical referencedata. The method includes making available a Web page for access by auser, where the Web page includes (i) data representing a hierarchy and(ii) rules defining modifications that are permitted to be made to data.The method also includes enabling a user to make a modification to thedata based on real-time enforcement of the rules.

Either of the above methods can have one or more of the followingfeatures. The method can also include performing local rule enforcementat a client. The method can also include comparing a first data elementof a first member of the hierarchy with a second data element of asecond member in the hierarchy to identify a possible conflict betweenthe first data element and the second data element. The possibleconflict can include the first data element being identical to thesecond data element. The first and second data elements can include anidentifier. The identifier can include a member code and/or a memberdescription.

The method can also include monitoring the real-time modification to thedata. The method can also include generating an audit report includinginformation corresponding to the real-time modification. The method canalso include monitoring other modifications occurring at other Webpages. The method can also include performing an application server ruleenforcement. The method can also include preventing the real-timemodification if the real-time modification conflicts with the othermodifications occurring at the other Web pages. The method can alsoinclude performing a master data rule enforcement. The method can alsoinclude preventing the real-time modification if the real-timemodification conflicts with an entry in stored master data.

The method can also include searching for a conflict and storing themodification if no conflict is found. The data representing thehierarchy can be a first set of data representing a first hierarchy, andthe method can also include making available a second set of datarepresenting a second hierarchy. The method can also include enablingthe user to move a portion of the second set of data to the first set ofdata. The method can also include preventing a modification to the movedportion of the second set of data. The method can also includemaintaining an original hierarchical relationship of the moved portionof the second set of data in the first hierarchy. The method can alsoinclude automatically updating the moved portion of the second set ofdata in the first hierarchy when there is a change to a portion of thesecond set of data in the second hierarchy corresponding to the movedportion of the second set of data in the first hierarchy.

The method can also include enabling a user to establish an arrangementof a portion of the hierarchy. The method can also include storing thearrangement of a portion of the hierarchy. One of the rules can includea conflict check. One of the rules can include preventing themodification if the user does not have permission to make themodification. The method can also include establishing permission usingan ownership attribute. The method can also include generating a reportbased on transactional data and the data representing the hierarchy. Themethod can also include making some portions of the transactional dataviewable and other portions of the transactional data summarized basedon the data representing the hierarchy. The method can also includeenabling the user to modify the data representing the hierarchy toindicate viewable and non-viewable portions. The method can also includenotifying a subscriber of the modification. The hierarchy can include anode tree.

In another aspect, there is a system including a computing device. Thecomputing device processes a Web page that includes (i) datarepresenting a hierarchy and (ii) rules enabling a user to make areal-time modification to the data based on the rules. The system canalso include one or more of the following features. The system can alsoinclude a client, which includes the computing device. The system canalso include a rule enforcement module that enables a user to make areal-time modification to the data based on the rules. The system canalso include a server, which includes the computing device. The systemcan also include a storage device storing the data representing thehierarchy. The system can also include a database including the datarepresenting a hierarchy. The system can also include a network whereinthe Web page is transmitted using the network.

In another aspect, there is an article that includes machine-readablemedium storing instructions operable to cause one or more machines toperform operations that include any combination of the methods describedabove.

There can be implementations that realize one or more of the followingadvantages. Providing some run-time management of user interfaces onclient independent of the software application on the server. There isno need to redisplay and reload all of the data when a save is made to ahierarchy. A reorganization of a company hierarchy can be accomplishedby a few drag and drop moves. The user interface enables this drag anddrop in a tree-like view in a Web environment. The rule enforcementmodule can be platform/device-independent, allowing standard browsers ondifferent client devices to incorporate the techniques described herein.There is an ease of deployment of software applications via existingInternet infrastructure while providing greater features than those ofstandard browsers. In other words, no need to deploy a separateapplication to each client individually. Extensive audit lists can begenerated. Users can subscribe to certain hierarchies, or portionsthereof, and receive notice of any modifications corresponding to thosecertain hierarchies, or portions thereof. A user can modify thehierarchical data to create a definition of summarized views when thehierarchical data is combined with transactional data. Oneimplementation of the invention provides all of the above advantages.

The details of one or more examples are set forth in the accompanyingdrawings and the description below. Further features, aspects, andadvantages of the invention will become apparent from the description,the drawings, and the claims.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 is a block diagram of a system to manage a hierarchy using anetwork.

FIG. 2 is a screenshot of a user interface to manage hierarchicalreference data.

FIG. 3 is a block diagram of a process to manage a hierarchy.

FIG. 4 is a block diagram of a hierarchy.

FIG. 5 is a block diagram of a system to manage a hierarchy by differentclients using a network.

FIG. 6 is a screenshot of a user interface to define summarized viewsusing the hierarchical reference data.

DETAILED DESCRIPTION

As shown in FIG. 1, a system 100 allows a user to interact with asoftware application 105 to manage hierarchical reference data used byother systems in an organization, such as a company. This hierarchicalreference data can include, for example, people of the company, costcenters of the company, products of the company, and departments of thecompany. System 100 includes a client 110 and an application server 115.Client 110 communicates with server 115 using network 120, for example,the Internet. Client 110 includes a display 125 and a browserapplication 130. Browser 130 communicates with server 115 using network120 to receive one or more Web pages transmitted from server 115. Whenthe user wants to interact with application 105, the user initiatesinteraction, for example, by entering a URL using browser 130.

As illustrated, in response to the browser request, server 115 providesa web page 135 to manage hierarchical reference data that includes arule enforcement module 140, hierarchical reference data 145, and a setof rules 150. Browser 130 processes the contents of Web page 135 andbased on the contents, renders a user interface 155 through which a userinteracts with hierarchical reference data 145 and application 105executing on server 115. User interface 155 enables the user to view andmanipulate hierarchical reference data 145 using rules 150, which definehow a user can modify hierarchical reference data 145. Rule enforcementmodule 140 represents executable code to effect manipulation ofhierarchical reference data 145 and rule checking. Rule enforcementmodule 140 is implemented using, for example, JavaScript, VBScript,and/or remote scripting. The code implementing rule enforcement module140 (or portions thereof) can be, for example, embedded directly inreceived Web page 135 and/or stored as a separate file that isreferenced in received Web page 135 and downloaded by browser 130 whenbrowser 130 processes received Web page 135. Although Web page 135 showsrule enforcement module 140 and rules 150 as two separate entities, theycan be combined and implemented as a single entity. For example, in someimplementations Web page 135 includes a data portion, a layoutinformation portion, and a logic portion. The data portion includes, forexample, hierarchical reference data 145. The layout information portionincludes, for example, the look and feel of UI 155, its controls, andhow the data of the data portion is displayed. The logic portionincludes, for example, scripting code (e.g., JavaScript) to control theuser interaction with UI 155. In such implementations, rule enforcementmodule 140 and rules 150 are combined and included in the logic portionof Web page 135.

Application 105 generates, maintains, retrieves, and/or manipulatesmaster hierarchical reference data 160 on the server-side of network120. Master hierarchical reference data 160 is stored in a storagemodule 165. For example, storage module 165 can include a database thatstores master hierarchal reference data 160. Application 105 also trackschanges being made to hierarchical reference data 145 at client 110.Tracking remote changes allows application 105 to transmit those changesto other client devices that are displaying the same hierarchicalreference data. Tracking changes also allows application 105 to performreal-time database rule enforcement based on master hierarchicalreference data 160 (e.g., ensure that key fields with unique identifiersare not duplicated).

Rule enforcement module 140 provides three types of rule enforcement.The first type is local rule enforcement. Rule enforcement module 140performs this type of rule enforcement exclusively at client 110 andindependent of application 105 and storage module 165. That is, ruleenforcement module 140 does not need to transmit data over network 120to perform local rule enforcement. The second type of enforcement isapplication server rule enforcement. Rule enforcement module 140performs this type of rule enforcement by sending the appropriate callsto server 115 to enforce rules involving multiple users when modifieddata has not yet been saved to master hierarchical reference data 160.The third type of enforcement is master data rule enforcement. Ruleenforcement module 140 performs this type of rule enforcement by sendingthe appropriate calls to server 115 to enforce rules involving masterhierarchical reference data 160.

Local rule enforcement is real-time hierarchy data management on client110 when the user, using UI 155, changes hierarchical reference data 145associated with received Web page 135. To perform hierarchy managementat client 110, rule enforcement module 140 tracks user modifications tohierarchical reference data 145. When rule enforcement module 140determines there has been a change to the data (e.g., detection of a oneor more browser events to the displayed hierarchy data in UI 155), ruleenforcement module 140 compares the requested change to rules 150 todetermine whether the change violates any rules 150. If the change doesnot violate any rules 150, rule enforcement module 140 modifieshierarchal reference data 145.

For example, to copy anode from one hierarchy to another, a user clickson a node of a displayed hierarchy and drags that node, using a mouse,from its current parent node to a new parent node. As soon as ruleenforcement module 140 becomes aware of the new parent node (e.g., thenew parent node is selected as the cursor touches the new parent, forexample, on a mouse over event) rule enforcement module 140 checks themove with rules 150. If the move is allowed by rules 150, when the userselects the new parent node (e.g., releases the mouse button), theselected node is copied to the new parent node. If the move is notallowed by rules 150, when the user releases the dragged portion (e.g.,releases the mouse button), the selected node does not copy over to thenew parent node, but simply remains with the previous parent node.

For the above modification and for other modifications, rule enforcementmodule 140 can perform the application server rule enforcement and themaster data rule enforcement in addition to the local rule enforcement.Rule enforcement module 140 uses rules 150 to determine whichcombination of the three rule enforcement types to invoke. For example,rules 150 can state that when a unique identifier (e.g., member code) ismodified, rule enforcement module 140 performs all three of the types ofrule enforcement. For the local rule enforcement, rule enforcementmodule 140 verifies that the unique identifier does not exist inhierarchical reference data 145 at client 110. For the applicationserver rule enforcement, rule enforcement module 140 sends the requestedchange to application 105 over network 120 using a proper call to causeprogram 105 to check the unique identifier against changes application105 is tracking at other clients that have not been saved to masterhierarchical reference data 160. For the master data rule enforcement,rule enforcement module 140 also sends the requested change toapplication 105 over network 120 using a proper call to cause program105 to check the unique identifier against master hierarchical data 160to determine whether there is a database conflict with masterhierarchical reference data 160. In some implementations, there ruleenforcement module 140 uses a single call to invoke both the applicationserver rule enforcement and the master data rule enforcement for themodification.

Rule enforcement module 140 performs the remote rule enforcement (i.e.,server rule enforcement and master data rule enforcement) withoutcausing a refresh of data (i.e., reload Web page 135). To accomplishthis, rule enforcement module 140 uses a remote scripting technique.Remote scripting enables client 110 to access code on the server side ofnetwork 120 without refreshing Web page 135. The remote scriptingtechnique enables a static HTML Web page (e.g., page 135) to behave as atraditional client-server application. The remote scripting techniquegenerates an interface between client 110 and server 115 using a hiddenapplet on Web page 135. The applet, through client side scripting,(e.g., VBScript or JavaScript) makes a URL connection to a server sideactive server page (ASP) (e.g., generated by application 105), which canconnect to backend data storage (e.g., storage module 165) or performmiddle tier business logic.

The remote scripting technique performs communication between client 110and server 115 synchronously or asynchronously. When communicatingasynchronously, the remote scripting technique specifies a callbackfunction along with the method call to server 115. This callbackfunction is invoked on return of the asynchronous method. Asynchronouscommunication is advantageous for longer running backend validations forexample, which allow the user to make a request and continue working onthe page without having to wait for the results. Synchronous methodsblock until the call returns, which is usually not an issue for shortermethod calls. Browsers manufactured by Microsoft Corporation of Redmond,Wash. and Netscape Communications Corporation of Mountain View, Calif.support the remote scripting technique. Some versions of the browser byNetscape Communications Corporation use Sun Microsystems' Java plug-in,which requires applets making socket connections to be signed.

FIG. 2 illustrates a screenshot 200 that provides an example of UI 155.Screenshot 200 includes a first area 203 and a second area 206, both ofwhich display hierarchical reference data. First area 203 also enablesthe user to modify the hierarchical reference data. Screenshot 200 alsoincludes a row of tabs 209 that enables a user to select from multiplefunctions. Tab 209 a, entitled “Hierarchy Maintenance”, enables the userto select and modify hierarchical reference data. The user chooses adimension using pull down box 211. A dimension is an overall wrapperassociated with a particular group of reference information for acompany. For example, one dimension might be internal services, whichholds all of the services offered by a company and their hierarchies(e.g., groups of services arranged hierarchically). As illustrated inscreenshot 200, the user has selected the dimension “INTERNALSERVICE” inbox 211. The user chooses a root node of display area 203 using pulldown box 214. As illustrated in screenshot 200, the user has selectedthe root node “DRVCD” in box 214. The user clicks on a “Load Hierarchy”button 217 and the Web browser (e.g., browser 130) displaying screenshot200 requests a Web page containing the selected hierarchical referencedata.

Referring to area 203, the hierarchical reference data includes a parentnode 219 and five children nodes 221 a, 221 b, 221 c, 221 d, and 221 e,generally referred to as 221. The nodes of the hierarchical referencedata are also referred to as members. Pull down box 224 enables the userto select how the members of the hierarchical reference data aredisplayed. As illustrated, because the selection made in box 224 is“Codes and descriptions”, members 219 and 221 are displayed in area 203using member codes 227 (e.g., ALT1) and member descriptions 230 (e.g.,Customer Driven). The arrangement of children nodes 221 is inalphanumeric order, using the member codes (e.g., 227). This may be adefault arrangement. The user can modify this arrangement, for exampleby moving member 221 e to the top of the list before member 221 a. Ifsuch an arrangement is allowable (e.g., does not violate the rules), themaster hierarchical data (e.g., 160) is updated with this newarrangement and every time this hierarchy, or a hierarchy with a copiedparent node 219, is subsequently displayed, children nodes 221 arearranged with member 221 e on the top.

Expansion and contraction buttons 233 enable the user to select whathierarchical levels are displayed in area 203. For example, button 233 aexpands (e.g., displays the children nodes) of the currently highlightednode. As illustrated, with node 219 highlighted, clicking button 233 a(e.g., moving a cursor over the button using a mouse and clicking amouse button) causes the children nodes 221 to be displayed. Button 233b expands all of the nodes from root node 219 to the nodes at the lowesthierarchical level of the hierarchical reference data. Button 233 ccontracts (e.g., remove from display) the children of the highlightednode. With node 219 highlighted, pressing button 233 c causes thechildren nodes 221 to be removed from display in area 203. Button 233 dcontracts all of the children nodes, leaving only the parent root node(e.g., 219) displayed. The user can also effect expansion andcontraction by clicking on the boxes with the “−” (contract) or “+”(expand) symbols that precede the member codes 227. In one example, area203 is generated using TreeView controls available if client 110 employsa MICROSOFT® WINDOWS® operating system, manufactured by MicrosoftCorporation of Redmond, Wash.

The user can display the attributes (and their current values) ofmembers 219 and 221 of the hierarchical reference data by clicking on a“Display Attributes” button 236. For example, a member that is a costcenter type can display the attribute cost center manager, with thevalue being the person or group who manages that member, the attributephysical location, with the value being the state in which that memberis located, the attribute purpose of cost center, with the value beingthe type of expenses for that member, and/or the attribute status ofmember, with the value being active or inactive. Visual indicators 240a, 240 b, and 240 c indicate to a user whether, based on rules 150, amember of the hierarchical reference data displayed in area 203 iseditable (240 a), non-editable (240 b) or inactive (240 c). An inactivemember is a member to which other applications can no longer posttransactions, but is still maintained in a hierarchy for historicaldata. To accomplish visual indication, screenshot 200 can display, forexample, each of visual indicators 240 a, 240 b, and 240 c usingdifferent colors and then display the members 219 and 211 in acorresponding color.

To enable a user to modify the hierarchical reference data, screenshot200 includes buttons 243 a, 243 b, 243 c, 243 d, 243 e, 243 f, 243 g,and 243 h. Button 243 a enables a user to insert a new member as a childmember under a currently highlighted member. Button 243 b enables a userto delete a currently highlighted member. Button 243 c enables a user tocut (i.e., delete) a currently highlighted member and button 243 denables a user to paste (i.e., insert) that cut member as a child memberunder a currently highlighted member. Button 243 e enables a user toedit the member description (e.g., 230) of a currently highlightedmember. Button 243 f enables a user to search for a member using, forexample, a keyword, a member code (e.g., 227), and/or a memberdescription (e.g., 230). In one example, screenshot 200 displays the oneor more members that match the entered search term(s) in area 203 byexpanding and contracting the hierarchical reference data as needed.Button 243 g enables a user to update the master hierarchical referencedata (e.g., data 160 in storage module 165) to incorporate themodifications that the user made. Button 243 h enables a user to exportthe hierarchical reference data of area 203 to another application, forexample, as illustrated to a MICROSOFT® Excel spreadsheet applicationmanufactured by Microsoft Corporation of Redmond, Wash.

As illustrated, screenshot 200 also has area 206 to display a second setof hierarchical reference data. The user chooses a hierarchy to displayusing pull down box 248. Similar to box 214, box 248 includes all of thehierarchies of the dimension “INTERNALSERVICE” in box 211. The userchooses a root node of display area 206 using text entry box 252. Asillustrated in screenshot 200, the user has selected the root node“SVCCD” in box 252. The user clicks on a “View Hierarchy” button 255 andthe Web browser (e.g., browser 130) displaying screenshot 200 displaysthe selected hierarchical reference data in area 206. If the user doesnot know the member description for the desired root node, button 258enables the user to search the member descriptions for the members ofthe hierarchy selected in box 248.

Similar to area 203, area 206 also has a pull down box 261 that enablesthe user to select how the members of the hierarchical reference dataare displayed, expansion and contraction buttons 264, and a displayattributes button 265. Area 206 also has button 268 that enables a userto search for a particular member and button 272 that enables a user toexport the hierarchical reference data of area 206 to anotherspreadsheet application. Although not shown, in other examples, area 206can also include edit buttons similar to buttons 243 a-h of area 203 toenable a user to modify the hierarchical reference data displayed inarea 206. By having two hierarchies displayed, a user can advantageouslyuse one hierarchy to modify a second hierarchy. For example, a user canselect one of the members displayed in area 206 and drag that memberinto the hierarchical reference data displayed in area 203.

When a member is copied from area 206 to area 203, the attributes ofthat member and any of its children nodes are also copied. This ensuresthat the particular member copied remains consistent (i.e., keeps thesame attributes and children members) throughout any hierarchies of thecompany. To further ensure consistency, as described in more detailbelow, some implementations include a rule that does not allow a user tomodify the copied member (e.g., change its attributes or children), butonly allows changes to the original, originating member. In suchexamples, application 105 tracks the hierarchies to which the member iscopied, so that when a user changes the originating member, application105 updates all copies of that member accordingly, keeping all copies ofthat member consistent with the original. For example, if a user copiesa member from a first hierarchy to a second hierarchy, application 105tracks that copy. When a user subsequently modifies the originatingmember in the first hierarchy, for example adds a new child member,application 105 automatically modifies the second hierarchy, adding thenew child member to the copied member in the second hierarchy. When auser subsequently displays the second hierarchy, the new child member isdisplayed.

FIG. 3 illustrates an example process 300 for updating a hierarchy. Auser, using browser application 130, requests and receives 310 a Webpage from server 115. This Web page includes a hierarchy and rules aboutmodifying the hierarchy. The display of the Web page can be, forexample, as illustrated by screenshot 200. If the user desires to make amodification to a single hierarchy, the user attempts 320 to modify amember of the hierarchy displayed on the Web page. Rule enforcementmodule 140 compares the attempted modification to the rules to determine330 whether the attempted modification violates any rules. As describedabove, this rule validation can include any combination of local rules,application server rules, and/or database rules. For example, two rulesmay be that the user may update a particular member of the hierarchy ifthat user possess the necessary permission (e.g., is listed as an ownerof that member) and the member is not a member copied from anotherhierarchy. If rule enforcement module 140 determines 330 that theattempted modification does not violate any rules, rule enforcementmodule 140 allows 340 the modification. If rule enforcement module 140determines 330 that the attempted modification does violate a rule, thenthe modification is not allowed 350. In some examples, the user may benotified that the attempted modification is not allowed and a reason forthe denial may be displayed.

In some cases, a user may desire to modify a hierarchy by dragging oneor more members from a second hierarchy (e.g., dragging a member fromarea 206 to area 203). In this situation, process 300 updates 360 thedisplay with data from the second hierarchy and any new rules associatedwith the new hierarchy. In one example, all of the hierarchiesassociated with a dimension (e.g., INTERNALSERVICE dimension indicatedin box 211 of screenshot 200) are transmitted when browser 130 receives310 the Web page. In such an example, all of the data and rulesassociated with any hierarchies of the dimension are already included inthe Web page and no server round trips are needed to display theadditional data. In another example, upon a request for the additionalhierarchy, server 115 generates another Web page that includes the firsthierarchy currently displayed and the second desired hierarchy. Whenbrowser 130 receives 310 the new Web page, browser 130 generates 360 anew UI 155 based on the new Web page, using known techniques to preventflickering as much as possible. In yet another example, a documentobject model (DOM) is employed so that portions of the displayed Webpage can be changed dynamically.

As described above, when a user attempts 320 to modify any of thehierarchies, rule enforcement module 140 determines 330 whether theattempted modification violates any rules. In the case of multiplehierarchies, UI 115 can allow the user to drag a member of one hierarchyto another hierarchy. This modification may require additional rules.For example, a user may only be able to drag nodes over which he hascontrol, but no nodes superior to those. Further, another rule mayrequire that when a member of a hierarchy is copied from one hierarchyto another, that portion can only be modified in the original hierarchyfrom which that portion came. For example, in the first, originalhierarchy, the portion corresponds to an indicator (e.g., 240 a)indicating that the members of that portion are editable. In any otherhierarchies to which the portion is copied, the portion corresponds toan indicator (e.g., 240 b) indicating that the members of that portionare not editable.

FIG. 4 shows an example hierarchy 400 that includes members 405 a-r thatrepresent cost centers of a company. As illustrated, members 405 a-rinclude a member code that is a three digit number, which couldrepresent, for example, an cost center number. Members 405 a-r alsoinclude a member description that is a letter, which could represent,for example, a name for the cost center. As an illustrative example,this hierarchy can be part of hierarchical reference data 145 ofreceived Web page 135 and the user requesting hierarchy 400 can belisted as an owner of member 405 f (e.g., the userid of the user is avalue for the owner attribute of member 405 f). The system can determinethat the user is the owner of member 405 f, for example, by using theuser credentials (e.g., userid) during an authentication process andcomparing that to the owner attribute value of member 405 f to verifythere is a match.

For one example modification, the user desires to add a new member 410to hierarchy 400 representing a new subordinate cost center. The rulesassociated with hierarchy 400 govern the adding a member to hierarchy400. For example, a rule can include a restriction that a new membercannot have a member description (e.g., cost center name) and/or membercode (e.g., cost center number) that conflicts with (e.g., is identicalto) another member in hierarchy 400. For this example, rule enforcementmodule 140 does not allow new member 410 to have a member code of 011 ora member description of “M” because both are already used in hierarchy400 by members 405 k and 405 m, respectively, and such use would cause aconflict.

To avoid a conflict, the user enters a member code of 019 and a memberdescription of “S” for new member 410. Rule enforcement module 140analyzes these new entries using rules 150 (e.g., no conflict with othermember codes or descriptions of the hierarchy) in real-time. That is,upon entering the data for new member 410 (e.g., clicking a submitbutton, hitting enter key, and the like), compares the entered membercode and description with all of the member codes and descriptions ofhierarchy 400. Because in this example Web page 135 includes all ofhierarchy 400, rule enforcement module 140 only has to do a local ruleenforcement on client 110 to verify there is no conflict with anymembers 405 a-r in hierarchy 400.

As described above, these conflict checks are performed in real-time(e.g., as the user is attempting to effect the modification) so if thereis a conflict, rule enforcement module 140 does not display the newmember and instead generates an error message, for example, stating thatthe member code/description conflicts with another membercode/description in the hierarchy. If there are no conflicts, new member410 is displayed in hierarchy 400. As described above, the system savesthe arrangement of the members as modified by the user. So in thisexample, where new member 410 precedes member 405 n, that arrangementwould be saved and presented to any subsequent requesters.

The rule can be broader than a conflict with hierarchy 400. The rule canstate that there can be no conflicting member codes or descriptions in adimension. Rule enforcement module 140 can verify in real-time that theentered member code and member description for new member 410 does notconflict with any other members in the dimension. In an example wherethe received Web page includes all of the hierarchies of a dimension,hierarchy 400 being only one of those hierarchies, rule enforcementmodule 140 can verify without making any calls to server 115.

The rule can be broader than a conflict within a dimension. The rule canstate that there can be no conflicting member codes or descriptions inall of the master hierarchical reference data 160 in storage module 165(e.g., within a database). Rule enforcement module 140 can verify inreal-time that the entered member code and member description for newmember 410 does not conflict with any other members in masterhierarchical reference data 160 by sending a proper call to application105 (e.g., perform the application server rule enforcement and themaster data rule enforcement described above). After performing theconflict check, application 105 returns an answer to rule enforcementmodule 140 and rule enforcement module 140 allows the modification orgenerates an error message based on the answer. This can be doneseemingly instantaneously, depending on the latencies of network 120.

Another example rule can govern the movement of members within thehierarchy. For example, the user, who is the owner of member 405 f, maydesire to move superior parent member 405 b to be a subordinate childmember of member 405 f. The rule can state that an owner of a member ofhierarchy 400 may only move the members 405 of hierarchy 400 that aresubordinate to the members for which the user is the owner. Under thisrule, rule enforcement module 140 allows the owner of member 405 f torearrange hierarchy 400 such that member 405 p can be a subordinatechild to member 405 q and therefore located under member 405 onhierarchy 400. This rule would not, however, allow the owner of member405 f to move member 405 b.

Another rule can limit any modification of a member to the owner of thatmember. In one example, the owner of a node is identified in anattribute of that member. For example, in hierarchy 400, the user is theowner of member 405 f. This example rule states that only the owner of amember can modify a member, for example, change the member descriptionor add new child nodes. Further, the owner of a node can be determinedthrough inheritance. For example, the user is also the owner of childrenmembers 405 n-r because no other owners are defined for members 405 n-rand members 405 n-r are children of member 405 f for which ownership isdefined. In another example, a second user is the defined owner formember 405 a and the first user is the defined owner for member 405 f.Through inheritance, the second user can modify (e.g., change the memberdescription) member 405 b, which does not have a defined owner, but notmember 405 f, which has a different defined owner (i.e., the firstuser). However, as described above, the rule for moving members, ifcombined with this rule, may still allow the second user to move member405 b and all of its subordinate members (405 e-g and 405 n-r), forexample, to place them subordinate to member 405 c, even though thesecond user cannot modify some of those children members (e.g., 405 fand 405 n-r) due to ownership constraints.

As described above, another rule can prohibit any modification tomembers that are copied, restricting modification only to the original,originating members. For an illustrative example, let member 405 c be acopied member from another hierarchy. In the originating hierarchy,member 405 c has children members 405 h-j, so the copied member alsoincludes children members 405 h-j. If the user attempts to modify member405 c, rule enforcement module 140 prevents such modification becausemember 405 c is a copied member, not the originating member. The userhas to request the originating hierarchy to make the modifications. Asdescribed above, application 105 tracks all copied members and anychanges to the originating member. If the originating member is changedto add another child member, then application 105 also adds a copy ofthat child to the copied member 405 c in the master data 160 so that asubsequent display of hierarchy 400 also includes a copy of that newchild member added to the originating member. In some examples, thiscopy rule is combined with the ownership rule described above. In theseexamples, a user cannot modify a member unless the user is the owner ofthat member and the member is an originating member, not a copiedmember.

FIG. 5 illustrates a system 500 that includes a plurality of n clients(e.g., 110 a to 110 b) that communicate with server 115 using network120. Client 110 a and client 110 b may each request hierarchicalreference data form the master hierarchical reference data 160.Application 105 tracks, for example, what hierarchies are being updated,who is doing the updating, and what new member codes and/or descriptionsare being created. In one example, rule enforcement module 140 transmitseach modification, and any other information application 105 iscollecting, to application 105, even though the user has not saved(e.g., pressed button 243 g of screenshot 200) those modifications tomaster hierarchical reference data 160. By tracking this data on areal-time basis, application 105 can provide several additional featuresfor managing hierarchical reference data. One feature application 105provides is an extensive audit list of modifications. If someone in thecompany generates a report that combines transactional data with thehierarchical reference data, and there is a mismatch, that person canuse the audit report to find out who modified the particular memberspresenting the problem and when they did so.

Another feature application 105 provides is a subscription service. Thesubscription service allows any user to subscribe to changes for one ormore particular members, whether or not that user is an owner of themember. Application 105 notifies the subscriber when there is a changeto the member corresponding to that subscription. The subscription alsoor alternatively can correspond to a different level, such as to aparticular hierarchy or a particular dimension. The subscriber canselect the channel of notification, for example, by providing an emailaddress to receive notifications about changes via email.

Another feature application 105 provides is the use, by client 110 b, ofmodifications made at client 110 a but not yet saved to masterhierarchical data 160. For example, a rule may state that a memberdescription has to be unique within a hierarchy, but can be repeatedwithin a dimension. The user of client 110 a makes a modification,defining a new member description as SDE, which stands for softwaredevelopment engineering. Because application 105 tracks this, the userat client 110 b can use this newly defined description also.

Another service that application 105 provides is enabling a user todefine a summarized view of a report that combines a hierarchicalreference data 145 with transactional data stored by the company onanother database. A summarized view is a restrictive view that allowsthe reader of a report to only view a portion of the members included inhierarchical reference data 145. A summarized view also presents summaryinformation about the members of hierarchical reference data 145 thatthe user is not allowed to view. In other words certain members ofhierarchical reference data 145 are displayed and other members aresummarized. The non-viewable members are summarized at a viewablehierarchically higher member (e.g., parent, grandparent, and the like).

FIG. 6 illustrates a screenshot 600 of a different example of UI 155that enables a user to define summarized views using hierarchicalreference data 145. Similar to screenshot 200, screenshot 600 includesan area 605 that displays hierarchical reference data 145 and manysimilar controls to define the display in area 605. For example, theuser chooses a dimension using pull down box 211, and as illustrated inscreenshot 600, the user has selected the dimension “INTERNALSERVICE” inbox 211. The user chooses a root node of display area 605 using pulldown box 214. As illustrated in screenshot 600, the user has selectedthe root node “SVCCD” in box 214. The user clicks on “Load” button 217and the Web browser (e.g., browser 130) displaying screenshot 600requests a Web page containing the selected hierarchical reference data.Pull down box 224 enables the user to select how the members of thehierarchical reference data are displayed. As illustrated, because theselection made in box 224 is “Codes and descriptions”, members aredisplayed in area 605 using member codes (e.g., 0001) and memberdescriptions (e.g., Admin Voice). Expansion and contraction buttons 233enable the user to select what hierarchical levels are displayed in area605.

The user uses box 610 to select a preexisting summary view to modify orthe user can enter a name in box 610 to define a name for a new summaryview. The user uses buttons 615 to mark and unmark members to make themviewable and summarized, respectively, in the summary view named in box610. For example, the user selects member 620 (e.g., by clicking onmember 620). If the user clicks on button 615 a, the member 620 ismarked as summarized and not viewable (e.g., marked using reversevideo). The reverse video marking represents that the member is notviewable in that particular summary view, but summarized at the nearesthierarchically higher member (e.g., parent, grandparent, and the like).If the user clicks on button 615 b, the children members 635 a-c ofmember 620 are marked. If a user wants to unmark a previously markedmember or its children, the user clicks on button 615 c or 615 d,respectively. If a user has either marked or unmarked a member or itschildren and then the user changes her mind before performing anotheraction, she can click on button 615 e to undo the last modificationmade.

A member displayed using reverse video indicates that particular memberis not viewable when a report is generated. For example, the members inarea 605 reference services provided by the company for which anemployee may want to track costs. A report for costs is generated, forexample, by matching the members displayed in area 605 withtransactional data from another database in the company. In that reportfor costs, the viewer can view the costs corresponding to all unmarkedmembers (i.e., all members in 605 except 620, 625 a-c, and 630 a-h). Allcosts for members that are marked (i.e., members 620, 625 a-c, and 630a-h) are summarized up at the nearest hierarchically higher member(e.g., parent, grandparent, and the like). For example, because member635 is not marked, indicating member 635 is viewable, its markedsubordinate members 620 and 625 a-c are rolled up and summarized atmember 635. Similarly, because member 640 is not marked, indicatingmember 640 is viewable, its marked children members 630 a-h are rolledup and summarized at member 640.

The invention can be implemented in digital electronic circuitry, or incomputer hardware, firmware, software, or in combinations of them. Theinvention can be implemented as a computer program product, i.e., acomputer program tangibly embodied in an information carrier, e.g., in amachine-readable storage device or in a propagated signal, for executionby, or to control the operation of, data processing apparatus, e.g., aprogrammable processor, a computer, or multiple computers. A computerprogram can be written in any form of programming language, includingcompiled or interpreted languages, and it can be deployed in any form,including as a stand-alone program or as a module, component,subroutine, or other unit suitable for use in a computing environment. Acomputer program can be deployed to be executed on one computer or onmultiple computers at one site or distributed across multiple sites andinterconnected by a communication network.

Method steps of the invention can be performed by one or moreprogrammable processors executing a computer program to performfunctions of the invention by operating on input data and generatingoutput. Method steps can also be performed by, and apparatus of theinvention can be implemented as, special purpose logic circuitry, e.g.,an FPGA (field programmable gate array) or an ASIC (application-specificintegrated circuit). Modules can refer to portions of the computerprogram and/or the processor/special circuitry that implements thatfunctionality.

Processors suitable for the execution of a computer program include, byway of example, both general and special purpose microprocessors, andany one or more processors of any kind of digital computer. Generally, aprocessor will receive instructions and data from a read-only memory ora random access memory or both. The essential elements of a computer area processor for executing instructions and one or more memory devicesfor storing instructions and data. Generally, a computer will alsoinclude, or be operatively coupled to receive data from or transfer datato, or both, one or more mass storage devices for storing data, e.g.,magnetic, magneto-optical disks, or optical disks. Information carrierssuitable for embodying computer program instructions and data includeall forms of non-volatile memory, including by way of examplesemiconductor memory devices, e.g., EPROM, EEPROM, and flash memorydevices; magnetic disks, e.g., internal hard disks or removable disks;magneto-optical disks; and CD-ROM and DVD-ROM disks. The processor andthe memory can be supplemented by, or incorporated in special purposelogic circuitry.

To provide for interaction with a user, the invention can be implementedon a computer having a display device, e.g., a CRT (cathode ray tube) orLCD (liquid crystal display) monitor, for displaying information to theuser and a keyboard and a pointing device, e.g., a mouse or a trackball,by which the user can provide input to the computer (e.g., interact witha user interface element). Other kinds of devices can be used to providefor interaction with a user as well; for example, feedback provided tothe user can be any form of sensory feedback, e.g., visual feedback,auditory feedback, or tactile feedback; and input from the user can bereceived in any form, including acoustic, speech, or tactile input.

The invention can be implemented in a distributed computing system thatincludes a back-end component, e.g., as a data server, and/or amiddleware component, e.g., an application server, and/or a front-endcomponent, e.g., a client computer having a graphical user interfaceand/or a Web browser through which a user can interact with animplementation of the invention, or any combination of such back-end,middleware, or front-end components. The components of the system can beinterconnected by any form or medium of digital data communication,e.g., a communication network. Examples of communication networksinclude a local area network (“LAN”) and a wide area network (“WAN”),e.g., the Internet, and include both wired and wireless networks.

The computing system can include clients and servers. A client andserver are generally remote from each other and typically interactthrough a communication network.

The relationship of client and server arises by virtue of computerprograms running on the respective computers and having a client-serverrelationship to each other. Servers shown as a single entity can alsorepresent a group of servers (e.g., server farm) that has the serverfunctionality distributed among the group of servers.

The invention has been described using particular examples. Otherembodiments are within the scope of the following claims. The followingare examples for illustration only and not to limit the alternatives inany way. The steps of the invention can be performed in a differentorder and still achieve desirable results. Also, while a few rules havebeen described above, the system can include a full set of rules togovern modifications to the hierarchy. Although two example screenshotsare described above, the system also can generate other UIs to provideother functionality described above.

1. A method comprising: making available a Web page for access by auser, the Web page including (i) data representing a hierarchy and (ii)rules defining modifications that are permitted to be made to data; andenabling a user to make a real-time modification to the data based onthe rules.
 2. The method of claim 1 wherein enabling further comprisesperforming local rule enforcement at a client.
 3. The method of claim 2wherein performing local rule enforcement further comprises comparing afirst data element of a first member of the hierarchy with a second dataelement of a second member in the hierarchy to identify a possibleconflict between the first data element and the second data element. 4.The method of claim 3 wherein the possible conflict comprises the firstdata element being identical to the second data element.
 5. The methodof claim 3 wherein the first and second data elements comprise anidentifier.
 6. The method of claim 5 wherein the identifier comprises atleast one of a member code and a member description.
 7. The method ofclaim 1 further comprising monitoring the real-time modification to thedata.
 8. The method of claim 7 further comprising generating an auditreport including information corresponding to the real-timemodification.
 9. The method of claim 7 further comprising monitoringother modifications occurring at other Web pages.
 10. The method ofclaim 9 wherein enabling further comprises performing an applicationserver rule enforcement.
 11. The method of claim 9 wherein performingfurther comprises preventing the real-time modification if the real-timemodification conflicts with the other modifications occurring at theother Web pages.
 12. The method of claim 1 wherein enabling furthercomprises performing a master data rule enforcement.
 13. The method ofclaim 12 wherein performing further comprises preventing the real-timemodification if the real-time modification conflicts with an entry instored master data.
 14. The method of claim 1 further comprising:searching for a conflict; and storing the modification if no conflict isfound.
 15. The method of claim 1 wherein the data representing thehierarchy is a first set of data representing a first hierarchy, themethod further comprising making available a second set of datarepresenting a second hierarchy.
 16. The method of claim 15 furthercomprising enabling the user to move a portion of the second set of datato the first set of data.
 17. The method of claim 16 further comprisingpreventing a modification to the moved portion of the second set ofdata.
 18. The method of claim 16 further comprising maintaining anoriginal hierarchical relationship of the moved portion of the secondset of data in the first hierarchy.
 19. The method of claim 16 furthercomprising automatically updating the moved portion of the second set ofdata in the first hierarchy when there is a change to a portion of thesecond set of data in the second hierarchy corresponding to the movedportion of the second set of data in the first hierarchy.
 20. The methodof claim 1 enabling a user to establish an arrangement of a portion ofthe hierarchy.
 21. The method of claim 20 further comprising storing thearrangement of a portion of the hierarchy.
 22. The method of claim 1wherein one of the rules comprises a conflict check.
 23. The method ofclaim 1 wherein one of the rules comprises preventing the modificationif the user does not have permission to make the modification.
 24. Themethod of claim 23 further comprising establishing permission using anownership attribute.
 25. The method of claim 1 further comprisinggenerating a report based on transactional data and the datarepresenting the hierarchy.
 26. The method of claim 25 whereingenerating further comprises making some portions of the transactionaldata viewable and other portions of the transactional data summarizedbased on the data representing the hierarchy.
 27. The method of claim 26further comprising enabling the user to modify the data representing thehierarchy to indicate viewable and non-viewable portions.
 28. The methodof claim 1 further comprising notifying a subscriber of themodification.
 29. The method of claim 1 wherein the hierarchy comprisesa node tree.
 30. A method comprising: making available a Web page foraccess by a user, the Web page including (i) data representing ahierarchy and (ii) rules defining modifications that are permitted to bemade to data; and enabling a user to make a modification to the databased on real-time enforcement of the rules.
 31. A system comprising acomputing device that processes a Web page including (i) datarepresenting a hierarchy and (ii) rules enabling a user to make areal-time modification to the data based on the rules.
 32. The system ofclaim 31 further comprising a client including the computing device. 33.The system of claim 31 further comprising a rule enforcement module thatenables a user to make a real-time modification to the data based on therules.
 34. The system of claim 31 further comprising a server comprisingthe computing device.
 35. The system of claim 31 further comprising astorage device storing the data representing the hierarchy.
 36. Thesystem of claim 31 further comprising a database including the datarepresenting the hierarchy.
 37. The system of claim 31 furthercomprising a network wherein the Web page is transmitted using thenetwork.
 38. An article comprising a machine-readable medium storinginstructions operable to cause one or more machines to performoperations comprising: making available a Web page for access by a user,the Web page including (i) data representing a hierarchy and (ii) rulesdefining modifications that are permitted to be made to data; andenabling a user to make a real-time modification to the data based onthe rules, the modification generating a modified hierarchy.